package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.SqlType;
import org.zoomdev.zoom.dao.ddl._DDL_Column;
import org.zoomdev.zoom.dao.ddl._DDL_Primary;
import org.zoomdev.zoom.dao.ddl._DDL_Table;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "aqb_acc", simpleName = "", engine = MysqlDriver.InnoDB, comment = "账号AQB")
public class _DDL_AqbAcc {

    @_DDL_Column(name = "USER_ID", type = SqlType.INT, nullable = false, comment = "用户ID")
    private Integer userId;

    @_DDL_Column(name = "BASE_STATUS", type = SqlType.INT, nullable = false, comment = "基础状态，0：无效、1：有效")
    private Integer baseStatus;

    @_DDL_Column(name = "BASE_ACC_TYPE", type = SqlType.INT, nullable = false, comment = "基础账号类型，1：平安、2：内部户")
    private Integer baseAccType;

    @_DDL_Column(name = "BIND_ACCT_NO", type = SqlType.VARCHAR, size = 30, comment = "一类银行卡")
    private String bindAcctNo;

    @_DDL_Column(name = "SIGN_ACCT_NO", type = SqlType.VARCHAR, size = 50, nullable = false, comment = "三类户")
    private String signAcctNo;

    @_DDL_Column(name = "OPEN_SIGN_ID", type = SqlType.VARCHAR, size = 30, comment = "签约协议号")
    private String openSignId;

    @_DDL_Primary()
    @_DDL_Column(name = "MER_ORDER_NO", type = SqlType.VARCHAR, size = 50, nullable = false, comment = "开AQB商户号")
    private String merOrderNo;

    @_DDL_Column(name = "AQB_ACCT_NO", type = SqlType.VARCHAR, size = 50, comment = "AQB账号")
    private String aqbAcctNo;

    @_DDL_Column(name = "AQB_STATUS", type = SqlType.VARCHAR, size = 65, comment = "AQB账号状态")
    private String aqbStatus;

    @_DDL_Column(name = "AQB_BALANCE", type = SqlType.VARCHAR, size = 65, comment = "AQB账号余额")
    private String aqbBalance;

    @_DDL_Column(name = "REGISTE_TIME", type = SqlType.VARCHAR, size = 19, comment = "注册时间")
    private String registeTime;

    @_DDL_Column(name = "DESTROY_TIME", type = SqlType.VARCHAR, size = 19, comment = "注销时间")
    private String destroyTime;

    @_DDL_Column(name = "UPDATE_TIME", type = SqlType.VARCHAR, size = 19, comment = "更新时间")
    private String updateTime;

    @_DDL_Column(name = "BIND_ACCT_NO_CIPHERTEXT", type = SqlType.VARCHAR, size = 100, comment = "一类银行卡密文")
    private String bindAcctNoCiphertext;

    @_DDL_Column(name = "LOW_BALANCE_NOTIFY_COUNT", type = SqlType.INT, nullable = false, comment = "低余额推送次数")
    private Integer lowBalanceNotifyCount;

}
